Creating the Conditional Columns -Part 1 11

You will create each Conditional Column in Power Query Editor . Follow the Screen shots and GIF below in order to create the Conditional columns. You will do this for all 9 columns that need to be created. 

Step 1.

Click on Transform data in the home tab, in the power query editor select Add Column - select Conditional Column-

New column name-    .InterviewerPreparedness 

Column Name-     Survey Group 

Operator-  equals

Value-   Interviewer Preparedness

Output- Under Output choose select a column from the dropdown then select Rating from the columns

then click on OK.

To change the Data Type of .InterviewerPreparedness conditional column ,Click on Home tab and in the datatype select Whole Number.

Follow the same to create all the conditional columns.   


Conditional Column 2-

Conditional Column 3 -

Conditional Column 4 -


The link below provide information to create conditional columns in power query:

https://radacad.com/conditional-column-in-power-bi-using-power-query-you-can-do-anything

Creating the Conditional Columns -Part 1 11

You will create each Conditional Column in Power Query Editor . Follow the Screen shots and GIF below in order to create the Conditional columns. You will do this for all 9 columns that need to be created. 

Step 1.

Click on Transform data in the home tab, in the power query editor select Add Column - select Conditional Column-

New column name-    .InterviewerPreparedness 

Column Name-     Survey Group 

Operator-  equals

Value-   Interviewer Preparedness

Output- Under Output choose select a column from the dropdown then select Rating from the columns

then click on OK.

To change the Data Type of .InterviewerPreparedness conditional column ,Click on Home tab and in the datatype select Whole Number.

Follow the same to create all the conditional columns.   


Conditional Column 2-

Conditional Column 3 -

Conditional Column 4 -


The link below provide information to create conditional columns in power query:

https://radacad.com/conditional-column-in-power-bi-using-power-query-you-can-do-anything